package com.schoolcardinfo.biz.impl;

import java.util.List;

import com.schoolcardinfo.beans.ExpenseInfo;
import com.schoolcardinfo.biz.IExpenseInfoBiz;
import com.schoolcardinfo.dao.DBHelper;

public class ExpenseInfoBizImpl implements IExpenseInfoBiz{
	private DBHelper db=new DBHelper();
	@Override
	public List<ExpenseInfo> selectExpenseInfo(int sid) {
		String sql="";
		if(sid==0){
			sql="select * from expenseInfo";
		}else{
			sql="select * from expenseInfo where sid="+sid;
		}
		List<ExpenseInfo> list=db.find(sql, null, ExpenseInfo.class);
		if(list.size()>0){
			return list;
		}else{
			return null;
		}
	}
}
